UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6lkCt1ssI+nEWHw23NVlH7fbb7CXyqDwD5+YEEH69GY='
WHERE
key_id = '56a8d27be0c80c371e9514de75b9fe7e4935bcc566322e4d49df05cc5ab88625'
AND (
token = '6lkCt1ssI+nEWHw23NVlH7fbb7CXyqDwD5+YEEH69GY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)