UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgeP3yKxtCSkeSwTzTwVMmYaYmpMLSCgz38WBVhi4vI='
WHERE
key_id = '24cb9738d675324c196633aeae09be747f6748e106650ce4a69ad9ec187c8bf1'
AND (
token = 'vgeP3yKxtCSkeSwTzTwVMmYaYmpMLSCgz38WBVhi4vI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)