UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zH9IfY3TpD2rnj4rNRXPg6rE/OYIx7O73hQnzi2YtfQ='
WHERE
key_id = '1c0e9124ff4a0da320f7b667dcf9994e30265eedb91803a263f13ff1f8d7a180'
AND (
token = 'zH9IfY3TpD2rnj4rNRXPg6rE/OYIx7O73hQnzi2YtfQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)