UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HlGhuEdAJS2v0LM0c8aNa0FLiGKA9wK/cKp2B4RW/0U='
WHERE
key_id = 'bc8a31e72129a64aefcbb6b141965a84069662ca431f755d161c522cb7563dfc'
AND (
token = 'HlGhuEdAJS2v0LM0c8aNa0FLiGKA9wK/cKp2B4RW/0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)