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