UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7244832VrncyuoOFBi1n5sLdBUeAODOXuDgEk35bkA='
WHERE
key_id = '46afeb20c7a504e5340c11be121f6231c4d1ab4183ddd76a7246e645c27403f1'
AND (
token = 'z7244832VrncyuoOFBi1n5sLdBUeAODOXuDgEk35bkA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)