UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2YfKDoJOZDyGwMNWRR+eNxbG9WXTd9ynOdi+Z09L/8='
WHERE
key_id = 'a341f08c781e3e2540ebeba7c0708d29af91b5891dc1b09c553a8678958323a8'
AND (
token = 'z2YfKDoJOZDyGwMNWRR+eNxbG9WXTd9ynOdi+Z09L/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)