UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'deD9zG90Fqle4IIhyiyMcSSrJrgI6X3Mqzz32Gs3hVg='
WHERE
key_id = '518f89cd0d0e4725a15690818facf92f3f43608e29f48ae5fbfb887942b2ded9'
AND (
token = 'deD9zG90Fqle4IIhyiyMcSSrJrgI6X3Mqzz32Gs3hVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)