UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zfdsYF11SRTWt1TQZ6h8bOtkLeEJeQsxvX9Ton3KEQU='
WHERE
key_id = 'b36f37e5ee3bca5306e9df1803d1765af55c07907962c9025df98ae718fe4c0e'
AND (
token = 'zfdsYF11SRTWt1TQZ6h8bOtkLeEJeQsxvX9Ton3KEQU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)