UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '30/Z18cLvSQjt5O8KOshWIYGLLKHS9iCCXktY0uop1A='
WHERE
key_id = 'a7165b48da8aa2bbd36dc084418e4cd957e684b32bc90ca114de7ded24bb34b6'
AND (
token = '30/Z18cLvSQjt5O8KOshWIYGLLKHS9iCCXktY0uop1A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)