UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bRU5S47wjvh43CYjXjmYGNoUldJH6Aimlu+y3527BS4='
WHERE
key_id = '193f045c3046cec4c6f107648b87e23af19cac1be686151cd20a636c1bb00fb9'
AND (
token = 'bRU5S47wjvh43CYjXjmYGNoUldJH6Aimlu+y3527BS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)