UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BblSwKXYtKGx17aMP5mlMBZLVWPv0rPgY0yWR2sBXbw='
WHERE
key_id = '597c713144f3a5c9c65fa3de22f761ec63eb4920d1b017655e4b81de90bda5f3'
AND (
token = 'BblSwKXYtKGx17aMP5mlMBZLVWPv0rPgY0yWR2sBXbw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)