UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9+nZ4HdKbbszbEr6/W4WABQ8AwRMQqpz40J2XLrp0Zw='
WHERE
key_id = '8f9b5a4db82a7166b5e5031bb58a29491e4665fa48dba8b4fb56749739b8f051'
AND (
token = '9+nZ4HdKbbszbEr6/W4WABQ8AwRMQqpz40J2XLrp0Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)