UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBKSOEZXFp1cNoprmubdIypmGiPVC3mM5bWSIf9A5ts='
WHERE
key_id = '9d6b4ca98b1a4f9e4554dc0353e8f54d61b2c36445bb216a52e44f8f6c95cffd'
AND (
token = 'qBKSOEZXFp1cNoprmubdIypmGiPVC3mM5bWSIf9A5ts='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)