UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'THQO1kX7+jmHmMtnXiabbAgMlB5dRET5uMpEmSj+E7I='
WHERE
key_id = '7f3ac1dc6e3b59497cec572f39f9590f8db1bfa48c8849a695afd580ee150656'
AND (
token = 'THQO1kX7+jmHmMtnXiabbAgMlB5dRET5uMpEmSj+E7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)