UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B6r3EBt9ldPvbZyu+iHxqn2xxRo7cblg9UXuffeqLM4='
WHERE
key_id = 'c420a5540e5ef6999434193443b1d86589cc4857697cfb848cdb285ed8388447'
AND (
token = 'B6r3EBt9ldPvbZyu+iHxqn2xxRo7cblg9UXuffeqLM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)