UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0beZkBAxSfC8R494XLbesUNUkyjAZdO+F+ekFJ9BIqE='
WHERE
key_id = '24fe0b673b19125fa10d910a56aeffea3f193419ec5d84a7c3938b56eed745ee'
AND (
token = '0beZkBAxSfC8R494XLbesUNUkyjAZdO+F+ekFJ9BIqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)