UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UMthad+/V/6ZzenJfCH1J4oplitp0sREOBU1ma0BSvU='
WHERE
key_id = '31bba44d331f2ecd3a5b3fbe34db3318dbd939c0f0c698f3c38ac9ca1fe54694'
AND (
token = 'UMthad+/V/6ZzenJfCH1J4oplitp0sREOBU1ma0BSvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)