UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UuQqiLwM370hB51K7Hn4LZ1d9VDj3blWGm9vp1myF9U='
WHERE
key_id = '52a33a725a995c60c88a9b23c06df24d11e509cfdad40447a48d42872fcc2931'
AND (
token = 'UuQqiLwM370hB51K7Hn4LZ1d9VDj3blWGm9vp1myF9U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)