UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZQm/8lVhjDw5aMi6MzmR4Zq0Vt4fbkFPEXUsfZERyxg='
WHERE
key_id = '9cdf6dbbd3da1e4685129e6478fea08935c506c1d01860b412237665823b0d0b'
AND (
token = 'ZQm/8lVhjDw5aMi6MzmR4Zq0Vt4fbkFPEXUsfZERyxg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)