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