UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CgwCQOe/Y+Z20aKUtQLlGCRkQ2xBCNsALoVDMEPqzLw='
WHERE
key_id = '6ab902ca4e8a86d080dfa1acd05e32ab08723748eb2c5580812caee17e3c413a'
AND (
token = 'CgwCQOe/Y+Z20aKUtQLlGCRkQ2xBCNsALoVDMEPqzLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)