UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NrvRd0aeEp8v3ObuefyzRvtDA6HhTZRucuRLD3DWDc0='
WHERE
key_id = '27f8a6d3517ec4e12a23fd83edb786054745082c2af457d8a3962dc194c6216c'
AND (
token = 'NrvRd0aeEp8v3ObuefyzRvtDA6HhTZRucuRLD3DWDc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)