UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ghQjkyIF7HMg4hFmtSdoDQlYuH7ZMFASTztJruggeyk='
WHERE
key_id = '2429798895541e65b309ce33f2c8213eede5c801bddaa8084d6764f13a14aa7a'
AND (
token = 'ghQjkyIF7HMg4hFmtSdoDQlYuH7ZMFASTztJruggeyk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)