UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'htU7KSmwyf0iVQFt4ReL3oTXAvxFPLSNeIU0yK+GmsU='
WHERE
key_id = 'e531a8d101103fb4ea9895b163aab8b3c6fa537221423b5233df845a614cb2e4'
AND (
token = 'htU7KSmwyf0iVQFt4ReL3oTXAvxFPLSNeIU0yK+GmsU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)