UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LDzNy+cffBN2BbS+nfJR4YHD8lpuxqgL5WN1rLj1hVw='
WHERE
key_id = '02d617ce9d5848220d4b6efdfae91253696a703b47a8b2fe200271daffe72bb1'
AND (
token = 'LDzNy+cffBN2BbS+nfJR4YHD8lpuxqgL5WN1rLj1hVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)