UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5vcX/LVmaOr7bgFZJCzoj6HADimuhNTizBF+A5oF4DM='
WHERE
key_id = 'fef705d94d31674d8b403d25135f22d80b87dc09e143a24deb3092513d50ea9b'
AND (
token = '5vcX/LVmaOr7bgFZJCzoj6HADimuhNTizBF+A5oF4DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)