UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGjnm1dHEvcSFC42pSkltrnJcWCplVzOyW4SpOXrlOA='
WHERE
key_id = 'edfecbfca30830d8a7c4f620c2a47ee425035ceccb43977932708edd0e7ce28f'
AND (
token = 'pGjnm1dHEvcSFC42pSkltrnJcWCplVzOyW4SpOXrlOA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)