UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sgKTPcEbF8gNiRq0tE3BoeUV0HKvoYkwdZ5gAXM07uI='
WHERE
key_id = '4d18a41b055b3e59d2dfc00e3b0265e6b55263d44666ee012a56ebd2513629a9'
AND (
token = 'sgKTPcEbF8gNiRq0tE3BoeUV0HKvoYkwdZ5gAXM07uI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)